excel formula how to create strings containing double quotes

248

excel formula how to create strings containing double quotes - 

'The double quotation mark (") is ASCII character 34, so the 
'following Excel formula works:

=CHAR(34) & "Excel rocks." & CHAR(34)
'This formula will display:  "Excel rocks."

'Using triple double quotes has the same result:
="""Excel rocks."""

Comments

Submit
0 Comments

More Questions

vba array lengthvba code to remove duplicates from a column vba loop through files in folder
excel vba get the path of current workbookvba how to convert a column number into an Excel column excelvba check for directory
vba delete filevba check if file exists xlvba double quotes in string literal
xlvba check for folderxl vba double quotes in string literal excel formula how to create strings containing double quotes
excel vba copy values range to another rangexl vba check for folder excel-vba how to convert a column number into an excel column
VBA Loop through recordsetwrite to text file vb.net excel vba function to convert column number to letter
vba string to dateexcel vba wait vbs send keys
string to date vb excel vba check if directory exists
C
CSS
Objective-C
PHP
Java
C++
Javascript
Html
Python
SQL
Swift
Ruby
Go
R
TypeScript
Kotlin
Assembly
VBA
Scala
Rust
Elixir
Dart
Haskell
Perl
Fortran
Matlab
Scheme
Julia
Lua
Delphi
Pascal
Solidity
BASIC
ActionScript
Csharp